There are many uses for formulas. If you have a need for specialized data manipulation, you can do it with a formula.
To calculate a price discounted 15%:
{Orders_Detail.Unit Price}*.85
formula = {Orders_Detail.Unit Price}*.85
To change all the values in the Customer Name field to uppercase:
UpperCase ({Customer.Customer Name})
formula = UCase ({Customer.Customer Name})
To extract the first letter of the customer name:
formula = {Customer.Customer Name} (1)
To determine what month an order was placed:
formula = Month ({Orders.Order Date})
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |